Notes/Domino 6 and 7 Forum : RE: Problems with ODBC Select statement in Notes

Notes/Domino 6 and 7 Forum

RE: Problems with ODBC Select statement in Notes

RE: Problems with ODBC Select statement in Notes
Posted by ~Jennifer Ekponemarakoi on 12.Jan.04 at 05:20 PM using a Web browser
Category: Notes Client

Release: 6.0.3

Platform: Windows 2000

Try placing the select into a string first like:

qryString = "SELECT * FROM ORACLE_TABLE WHERE TRUNC(MY_DATE) > TO_DATE('" + sDATE.DateOnly + "','MM/DD/YYYY') - 1 AND TRUNC(MY_DATE) < TO_DATE('" + eDATE.DateOnly + "','MM/DD/YYYY') + 1"

OraQuery.SQL = qryString

+++++++++

That method usually works for me. Remember to make sure your quotes are escaped. Hard to tell here if they are, but they may cause you problems as well.